| Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
TermId |
|
INTEGER |
YES |
|
| Sequence |
|
NUMERIC(4, 0) |
NO |
|
| BilledDate |
|
DATETIME |
YES |
|
| TermGpa |
|
NUMERIC(11, 6) |
YES |
|
| TermNumericAverage |
|
NUMERIC(11, 6) |
YES |
|
| TermCreditHoursAttempted |
|
NUMERIC(9, 2) |
YES |
|
| TermCreditHoursEarned |
|
NUMERIC(9, 2) |
YES |
|
| TermClockHoursAttempted |
|
NUMERIC(9, 2) |
YES |
|
| TermClockHoursEarned |
|
NUMERIC(9, 2) |
YES |
|
| TermGpaPoints |
|
NUMERIC(9, 2) |
YES |
|
| TermMinutesAttended |
|
NUMERIC(11, 2) |
YES |
|
| TermMinutesAbsent |
|
NUMERIC(9, 2) |
YES |
|
| CumulativeGpa |
|
NUMERIC(11, 6) |
YES |
|
| CumulativeNumericAverage |
|
NUMERIC(11, 6) |
YES |
|
| CumulativeCreditHoursAttempted |
|
NUMERIC(9, 2) |
YES |
|
| CumulativeCreditHoursEarned |
|
NUMERIC(9, 2) |
YES |
|
| CumulativeClockHoursAttempted |
|
NUMERIC(9, 2) |
YES |
|
| CumulativeClockHoursEarned |
|
NUMERIC(9, 2) |
YES |
|
| CumulativeGpaPoints |
|
NUMERIC(9, 2) |
YES |
|
| CumulativeMinutesAttended |
|
NUMERIC(11, 2) |
YES |
|
| CumulativeMinutesAbsent |
|
NUMERIC(9, 2) |
YES |
|
| TermCreditHoursScheduled |
|
NUMERIC(9, 2) |
YES |
|
| TermClockHoursScheduled |
|
NUMERIC(9, 2) |
YES |
|
| Note |
|
VARCHAR(255) |
YES |
|
| SAPStatus |
|
CHAR(1) |
YES |
|
EnrollmentStatusId |
|
INTEGER |
YES |
|
| HonorsDescription |
|
VARCHAR(50) |
YES |
|
| CreatedDateTime |
|
DATETIME |
NO |
|
| LastModifiedDateTime |
|
DATETIME |
NO |
|
| LastModifiedUserId |
|
INTEGER |
NO |
|
| RowVersion |
|
TIMESTAMP/DATE |
NO |
|
HonorId |
|
INTEGER |
YES |
|
| SapStatusId |
|
INTEGER |
YES |
|
| StudentTermGpa |
|
NUMERIC(11, 6) |
YES |
|
| StudentTermCreditHoursAttempted |
|
NUMERIC(11, 2) |
YES |
|
| StudentTermClockHoursAttempted |
|
NUMERIC(11, 2) |
YES |
|
| StudentTermGpaPoints |
|
NUMERIC(11, 2) |
YES |
|
| StudentCumulativeGpa |
|
NUMERIC(11, 6) |
YES |
|
| StudentCumulativeCreditHoursAttempted |
|
NUMERIC(11, 2) |
YES |
|
| StudentCumulativeClockHoursAttempted |
|
NUMERIC(11, 2) |
YES |
|
| StudentCumulativeGpaPoints |
|
NUMERIC(11, 2) |
YES |
|
StudentEnrollmentTermSummaryId |
|
INTEGER |
NO |
|
| CumulativeGpaCredits |
|
NUMERIC(9, 2) |
YES |
|
| TermMinutesMakeupAttended |
|
INTEGER |
YES |
|
| CumulativeMinutesMakeupAttended |
|
INTEGER |
YES |
|
| BgRndSetIdentifier |
|
INTEGER |
NO |
|
| GradeLevelEvaluation |
|
BIT |
NO |
|
| GradeLevelEvauationlDate |
|
DATETIME |
YES |
|
| TermRegsteredCreditHours |
|
NUMERIC(9, 2) |
YES |
|
| TermRegisteredClockHours |
|
NUMERIC(9, 2) |
YES |
|
| StudentTermCreditHoursEarned |
|
NUMERIC(9, 2) |
YES |
|
| StudentTermClockHoursEarned |
|
NUMERIC(9, 2) |
YES |
|
| StudentCumulativeCreditHoursEarned |
|
NUMERIC(9, 2) |
YES |
|
| StudentCumulativeClockHoursEarned |
|
NUMERIC(9, 2) |
YES |
|
| TermAuditCreditHoursScheduled |
|
NUMERIC(9, 2) |
YES |
|
| TermAssociatedGpaNumerator |
|
MONEY(19, 4) |
YES |
|
| TermAssociatedGpaDenominator |
|
MONEY(19, 4) |
YES |
|
| SAPCheckpoint |
|
TINYINT |
NO |
|
| PartialSAPTerm |
|
BIT |
NO |
|
| SapProcessType |
|
CHAR(1) |
NO |
|
| StudentTermCreditHoursScheduled |
|
NUMERIC(9, 2) |
YES |
|
| StudentTermAuditCreditHoursScheduled |
|
NUMERIC(9, 2) |
YES |
|
| StudentTermClockHoursScheduled |
|
NUMERIC(9, 2) |
YES |
|
| StudentTermRegisteredCreditHours |
|
NUMERIC(9, 2) |
YES |
|
| StudentTermRegisteredClockHours |
|
NUMERIC(9, 2) |
YES |
|
| StudentTermEnrollmentStatusId |
|
INTEGER |
YES |
|
| TermGroupId |
|
INTEGER |
YES |
|
StudentId |
|
INTEGER |
YES |
|
StudentEnrollmentPeriodId |
|
INTEGER |
YES |
|
| Key Name |
Key Type |
Keys |
| AdEnrollTerm_AdEnrollTermID_U_C_IDX |
PrimaryKey |
StudentEnrollmentTermSummaryId |
| AdEnrollTerm_SyStudentID_N_N_IDX |
Inversion Entry |
Id_1 |
| AdEnrollTerm_AdTermID_AdAttStatId_AdEnrollId_AdEnrollTermID_U_N_IDX |
Alternate Key |
EnrollmentStatusId, Id_1 |
| AdEnrollTerm_AdEnrollID_Sequence_U_N_IDX |
Unique Constraint |
Id_1, Sequence |
| AdEnrollTerm_AdEnrollTermID_GradeLevelEval_N_N_IDX |
Inversion Entry |
Id_1, GradeLevelEvaluation |
| AdEnrollTerm_AdEnrollId_AdTermId_TermAuditCreditsSched_U_N_IDX |
Alternate Key |
Id_1, TermAuditCreditHoursScheduled |